/*
 Navicat Premium Data Transfer

 Source Server         : localhost_3306
 Source Server Type    : MySQL
 Source Server Version : 50720
 Source Host           : 127.0.0.1:3306
 Source Schema         : fslzpb

 Target Server Type    : MySQL
 Target Server Version : 50720
 File Encoding         : 65001

 Date: 02/11/2018 15:13:17
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for pb_action
-- ----------------------------
DROP TABLE IF EXISTS `pb_action`;
CREATE TABLE `pb_action` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键',
  `name` char(30) NOT NULL DEFAULT '' COMMENT '行为唯一标识',
  `title` char(80) NOT NULL DEFAULT '' COMMENT '行为说明',
  `remark` char(140) NOT NULL DEFAULT '' COMMENT '行为描述',
  `rule` text COMMENT '行为规则',
  `log` text COMMENT '日志规则',
  `type` tinyint(2) unsigned NOT NULL DEFAULT '1' COMMENT '类型',
  `status` tinyint(2) NOT NULL DEFAULT '0' COMMENT '状态',
  `update_time` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '修改时间',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=12 DEFAULT CHARSET=utf8 COMMENT='系统行为表';

-- ----------------------------
-- Records of pb_action
-- ----------------------------
BEGIN;
INSERT INTO `pb_action` VALUES (1, 'user_login', '用户登录', '积分+10，每天一次', 'table:member|field:score|condition:uid={$self} AND status>-1|rule:score+10|cycle:24|max:1;', '[user|get_nickname]在[time|time_format]登录了后台', 1, 1, 1387181220);
INSERT INTO `pb_action` VALUES (2, 'add_article', '发布文章', '积分+5，每天上限5次', 'table:member|field:score|condition:uid={$self}|rule:score+5|cycle:24|max:5', '', 2, 0, 1380173180);
INSERT INTO `pb_action` VALUES (3, 'review', '评论', '评论积分+1，无限制', 'table:member|field:score|condition:uid={$self}|rule:score+1', '', 2, 1, 1383285646);
INSERT INTO `pb_action` VALUES (4, 'add_document', '发表文档', '积分+10，每天上限5次', 'table:member|field:score|condition:uid={$self}|rule:score+10|cycle:24|max:5', '[user|get_nickname]在[time|time_format]发表了一篇文章。\r\n表[model]，记录编号[record]。', 2, 0, 1386139726);
INSERT INTO `pb_action` VALUES (5, 'add_document_topic', '发表讨论', '积分+5，每天上限10次', 'table:member|field:score|condition:uid={$self}|rule:score+5|cycle:24|max:10', '', 2, 0, 1383285551);
INSERT INTO `pb_action` VALUES (6, 'update_config', '更新配置', '新增或修改或删除配置', '', '', 1, 1, 1383294988);
INSERT INTO `pb_action` VALUES (7, 'update_model', '更新模型', '新增或修改模型', '', '', 1, 1, 1383295057);
INSERT INTO `pb_action` VALUES (8, 'update_attribute', '更新属性', '新增或更新或删除属性', '', '', 1, 1, 1383295963);
INSERT INTO `pb_action` VALUES (9, 'update_channel', '更新导航', '新增或修改或删除导航', '', '', 1, 1, 1383296301);
INSERT INTO `pb_action` VALUES (10, 'update_menu', '更新菜单', '新增或修改或删除菜单', '', '', 1, 1, 1383296392);
INSERT INTO `pb_action` VALUES (11, 'update_category', '更新分类', '新增或修改或删除分类', '', '', 1, 1, 1383296765);
COMMIT;

-- ----------------------------
-- Table structure for pb_action_log
-- ----------------------------
DROP TABLE IF EXISTS `pb_action_log`;
CREATE TABLE `pb_action_log` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键',
  `action_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '行为id',
  `user_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '执行用户id',
  `action_ip` bigint(20) NOT NULL COMMENT '执行行为者ip',
  `model` varchar(50) NOT NULL DEFAULT '' COMMENT '触发行为的表',
  `record_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '触发行为的数据id',
  `remark` varchar(255) NOT NULL DEFAULT '' COMMENT '日志备注',
  `status` tinyint(2) NOT NULL DEFAULT '1' COMMENT '状态',
  `create_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '执行行为的时间',
  PRIMARY KEY (`id`),
  KEY `action_ip_ix` (`action_ip`) USING BTREE,
  KEY `action_id_ix` (`action_id`) USING BTREE,
  KEY `user_id_ix` (`user_id`) USING BTREE
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='行为日志表';

-- ----------------------------
-- Table structure for pb_auth_group
-- ----------------------------
DROP TABLE IF EXISTS `pb_auth_group`;
CREATE TABLE `pb_auth_group` (
  `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT COMMENT '用户组id,自增主键',
  `module` varchar(20) NOT NULL DEFAULT '' COMMENT '用户组所属模块',
  `type` tinyint(4) NOT NULL DEFAULT '0' COMMENT '组类型',
  `title` char(20) NOT NULL DEFAULT '' COMMENT '用户组中文名称',
  `description` varchar(80) NOT NULL DEFAULT '' COMMENT '描述信息',
  `status` tinyint(1) NOT NULL DEFAULT '1' COMMENT '用户组状态：为1正常，为0禁用,-1为删除',
  `rules` varchar(500) NOT NULL DEFAULT '' COMMENT '用户组拥有的规则id，多个规则 , 隔开',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=8 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of pb_auth_group
-- ----------------------------
BEGIN;
INSERT INTO `pb_auth_group` VALUES (5, 'admin', 1, '一般管理员', '', 1, '1,238,239,240,241,265,398');
INSERT INTO `pb_auth_group` VALUES (7, 'admin', 1, '超级管理员', '', 1, '1,3,19,20,22,26,27,61,62,63,64,65,66,82,83,84,86,87,88,100,102,103,107,207,212,213,219,220,221,222,223,224,225,226,227,228,229,230,231,232,233,234,235,236,237,238,239,240,241,242,247,257,262,263,264,265,266,277,333,335,364,365,366,367,368,369,370,371,372,373,374,375,376,377,378,379,380');
COMMIT;

-- ----------------------------
-- Table structure for pb_auth_group_access
-- ----------------------------
DROP TABLE IF EXISTS `pb_auth_group_access`;
CREATE TABLE `pb_auth_group_access` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `uid` int(10) unsigned NOT NULL COMMENT '用户id',
  `group_id` mediumint(8) unsigned NOT NULL COMMENT '用户组id',
  PRIMARY KEY (`id`),
  UNIQUE KEY `uid_group_id` (`uid`,`group_id`) USING BTREE,
  KEY `uid` (`uid`) USING BTREE,
  KEY `group_id` (`group_id`) USING BTREE
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of pb_auth_group_access
-- ----------------------------
BEGIN;
INSERT INTO `pb_auth_group_access` VALUES (1, 2, 5);
INSERT INTO `pb_auth_group_access` VALUES (2, 3, 1);
INSERT INTO `pb_auth_group_access` VALUES (3, 4, 1);
INSERT INTO `pb_auth_group_access` VALUES (4, 1, 7);
COMMIT;

-- ----------------------------
-- Table structure for pb_auth_rule
-- ----------------------------
DROP TABLE IF EXISTS `pb_auth_rule`;
CREATE TABLE `pb_auth_rule` (
  `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT COMMENT '规则id,自增主键',
  `module` varchar(20) NOT NULL COMMENT '规则所属module',
  `type` tinyint(2) NOT NULL DEFAULT '1' COMMENT '1-url;2-主菜单',
  `name` char(80) NOT NULL DEFAULT '' COMMENT '规则唯一英文标识',
  `title` char(20) NOT NULL DEFAULT '' COMMENT '规则中文描述',
  `status` tinyint(1) NOT NULL DEFAULT '1' COMMENT '是否有效(0:无效,1:有效)',
  `condition` varchar(300) NOT NULL DEFAULT '' COMMENT '规则附加条件',
  PRIMARY KEY (`id`),
  KEY `module` (`module`,`status`,`type`) USING BTREE
) ENGINE=MyISAM AUTO_INCREMENT=399 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of pb_auth_rule
-- ----------------------------
BEGIN;
INSERT INTO `pb_auth_rule` VALUES (1, 'admin', 2, 'admin/Index/index', '首页', 1, '');
INSERT INTO `pb_auth_rule` VALUES (2, 'admin', 2, 'Admin/Article/index', '内容', -1, '');
INSERT INTO `pb_auth_rule` VALUES (3, 'admin', 2, 'admin/User/index', '后台用户', 1, '');
INSERT INTO `pb_auth_rule` VALUES (4, 'admin', 2, 'Admin/Addons/index', '扩展', -1, '');
INSERT INTO `pb_auth_rule` VALUES (5, 'admin', 2, 'Admin/Config/group', '系统', -1, '');
INSERT INTO `pb_auth_rule` VALUES (7, 'admin', 1, 'Admin/article/add', '新增', -1, '');
INSERT INTO `pb_auth_rule` VALUES (8, 'admin', 1, 'Admin/article/edit', '编辑', -1, '');
INSERT INTO `pb_auth_rule` VALUES (9, 'admin', 1, 'Admin/article/setStatus', '改变状态', -1, '');
INSERT INTO `pb_auth_rule` VALUES (10, 'admin', 1, 'Admin/article/update', '保存', -1, '');
INSERT INTO `pb_auth_rule` VALUES (11, 'admin', 1, 'Admin/article/autoSave', '保存草稿', -1, '');
INSERT INTO `pb_auth_rule` VALUES (12, 'admin', 1, 'Admin/article/move', '移动', -1, '');
INSERT INTO `pb_auth_rule` VALUES (13, 'admin', 1, 'Admin/article/copy', '复制', -1, '');
INSERT INTO `pb_auth_rule` VALUES (14, 'admin', 1, 'Admin/article/paste', '粘贴', -1, '');
INSERT INTO `pb_auth_rule` VALUES (15, 'admin', 1, 'Admin/article/permit', '还原', -1, '');
INSERT INTO `pb_auth_rule` VALUES (16, 'admin', 1, 'Admin/article/clear', '清空', -1, '');
INSERT INTO `pb_auth_rule` VALUES (17, 'admin', 1, 'Admin/Article/examine', '审核列表', -1, '');
INSERT INTO `pb_auth_rule` VALUES (18, 'admin', 1, 'Admin/article/recycle', '回收站', -1, '');
INSERT INTO `pb_auth_rule` VALUES (19, 'admin', 1, 'admin/User/addaction', '新增', 1, '');
INSERT INTO `pb_auth_rule` VALUES (20, 'admin', 1, 'admin/User/editaction', '编辑', 1, '');
INSERT INTO `pb_auth_rule` VALUES (21, 'admin', 1, 'Admin/User/saveAction', '保存用户行为', -1, '');
INSERT INTO `pb_auth_rule` VALUES (22, 'admin', 1, 'admin/User/setStatus', '变更状态', 1, '');
INSERT INTO `pb_auth_rule` VALUES (23, 'admin', 1, 'Admin/User/changeStatus?method=forbidUser', '禁用会员', -1, '');
INSERT INTO `pb_auth_rule` VALUES (24, 'admin', 1, 'Admin/User/changeStatus?method=resumeUser', '启用会员', -1, '');
INSERT INTO `pb_auth_rule` VALUES (25, 'admin', 1, 'Admin/User/changeStatus?method=deleteUser', '删除会员', -1, '');
INSERT INTO `pb_auth_rule` VALUES (26, 'admin', 1, 'admin/User/index', '用户信息', 1, '');
INSERT INTO `pb_auth_rule` VALUES (27, 'admin', 1, 'admin/User/action', '用户行为', 1, '');
INSERT INTO `pb_auth_rule` VALUES (28, 'admin', 1, 'Admin/AuthManager/changeStatus?method=deleteGroup', '删除', -1, '');
INSERT INTO `pb_auth_rule` VALUES (29, 'admin', 1, 'Admin/AuthManager/changeStatus?method=forbidGroup', '禁用', -1, '');
INSERT INTO `pb_auth_rule` VALUES (30, 'admin', 1, 'Admin/AuthManager/changeStatus?method=resumeGroup', '恢复', -1, '');
INSERT INTO `pb_auth_rule` VALUES (31, 'admin', 1, 'Admin/AuthManager/createGroup', '新增', -1, '');
INSERT INTO `pb_auth_rule` VALUES (32, 'admin', 1, 'Admin/AuthManager/editGroup', '编辑', -1, '');
INSERT INTO `pb_auth_rule` VALUES (33, 'admin', 1, 'Admin/AuthManager/writeGroup', '保存用户组', -1, '');
INSERT INTO `pb_auth_rule` VALUES (34, 'admin', 1, 'Admin/AuthManager/group', '授权', -1, '');
INSERT INTO `pb_auth_rule` VALUES (35, 'admin', 1, 'Admin/AuthManager/access', '访问授权', -1, '');
INSERT INTO `pb_auth_rule` VALUES (36, 'admin', 1, 'Admin/AuthManager/user', '成员授权', -1, '');
INSERT INTO `pb_auth_rule` VALUES (37, 'admin', 1, 'Admin/AuthManager/removeFromGroup', '解除授权', -1, '');
INSERT INTO `pb_auth_rule` VALUES (38, 'admin', 1, 'Admin/AuthManager/addToGroup', '保存成员授权', -1, '');
INSERT INTO `pb_auth_rule` VALUES (39, 'admin', 1, 'Admin/AuthManager/category', '分类授权', -1, '');
INSERT INTO `pb_auth_rule` VALUES (40, 'admin', 1, 'Admin/AuthManager/addToCategory', '保存分类授权', -1, '');
INSERT INTO `pb_auth_rule` VALUES (41, 'admin', 1, 'Admin/AuthManager/index', '权限管理', -1, '');
INSERT INTO `pb_auth_rule` VALUES (42, 'admin', 1, 'Admin/Addons/create', '创建', -1, '');
INSERT INTO `pb_auth_rule` VALUES (43, 'admin', 1, 'Admin/Addons/checkForm', '检测创建', -1, '');
INSERT INTO `pb_auth_rule` VALUES (44, 'admin', 1, 'Admin/Addons/preview', '预览', -1, '');
INSERT INTO `pb_auth_rule` VALUES (45, 'admin', 1, 'Admin/Addons/build', '快速生成插件', -1, '');
INSERT INTO `pb_auth_rule` VALUES (46, 'admin', 1, 'Admin/Addons/config', '设置', -1, '');
INSERT INTO `pb_auth_rule` VALUES (47, 'admin', 1, 'Admin/Addons/disable', '禁用', -1, '');
INSERT INTO `pb_auth_rule` VALUES (48, 'admin', 1, 'Admin/Addons/enable', '启用', -1, '');
INSERT INTO `pb_auth_rule` VALUES (49, 'admin', 1, 'Admin/Addons/install', '安装', -1, '');
INSERT INTO `pb_auth_rule` VALUES (50, 'admin', 1, 'Admin/Addons/uninstall', '卸载', -1, '');
INSERT INTO `pb_auth_rule` VALUES (51, 'admin', 1, 'Admin/Addons/saveconfig', '更新配置', -1, '');
INSERT INTO `pb_auth_rule` VALUES (52, 'admin', 1, 'Admin/Addons/adminList', '插件后台列表', -1, '');
INSERT INTO `pb_auth_rule` VALUES (53, 'admin', 1, 'Admin/Addons/execute', 'URL方式访问插件', -1, '');
INSERT INTO `pb_auth_rule` VALUES (54, 'admin', 1, 'Admin/Addons/index', '插件管理', -1, '');
INSERT INTO `pb_auth_rule` VALUES (55, 'admin', 1, 'Admin/Addons/hooks', '钩子管理', -1, '');
INSERT INTO `pb_auth_rule` VALUES (56, 'admin', 1, 'Admin/model/add', '新增', -1, '');
INSERT INTO `pb_auth_rule` VALUES (57, 'admin', 1, 'Admin/model/edit', '编辑', -1, '');
INSERT INTO `pb_auth_rule` VALUES (58, 'admin', 1, 'Admin/model/setStatus', '改变状态', -1, '');
INSERT INTO `pb_auth_rule` VALUES (59, 'admin', 1, 'Admin/model/update', '保存数据', -1, '');
INSERT INTO `pb_auth_rule` VALUES (60, 'admin', 1, 'Admin/Model/index', '模型管理', -1, '');
INSERT INTO `pb_auth_rule` VALUES (61, 'admin', 1, 'admin/Config/edit', '编辑', 1, '');
INSERT INTO `pb_auth_rule` VALUES (62, 'admin', 1, 'admin/Config/del', '删除', 1, '');
INSERT INTO `pb_auth_rule` VALUES (63, 'admin', 1, 'admin/Config/add', '新增', 1, '');
INSERT INTO `pb_auth_rule` VALUES (64, 'admin', 1, 'admin/Config/save', '保存', 1, '');
INSERT INTO `pb_auth_rule` VALUES (65, 'admin', 1, 'admin/Config/group', '网站配置', 1, '');
INSERT INTO `pb_auth_rule` VALUES (66, 'admin', 1, 'admin/Config/index', '配置属性', 1, '');
INSERT INTO `pb_auth_rule` VALUES (67, 'admin', 1, 'Admin/Channel/add', '新增', -1, '');
INSERT INTO `pb_auth_rule` VALUES (68, 'admin', 1, 'Admin/Channel/edit', '编辑', -1, '');
INSERT INTO `pb_auth_rule` VALUES (69, 'admin', 1, 'Admin/Channel/del', '删除', -1, '');
INSERT INTO `pb_auth_rule` VALUES (70, 'admin', 1, 'Admin/Channel/index', '导航管理', -1, '');
INSERT INTO `pb_auth_rule` VALUES (71, 'admin', 1, 'Admin/Category/edit', '编辑', -1, '');
INSERT INTO `pb_auth_rule` VALUES (72, 'admin', 1, 'Admin/Category/add', '新增', -1, '');
INSERT INTO `pb_auth_rule` VALUES (73, 'admin', 1, 'Admin/Category/remove', '删除', -1, '');
INSERT INTO `pb_auth_rule` VALUES (74, 'admin', 1, 'Admin/Category/index', '分类管理', -1, '');
INSERT INTO `pb_auth_rule` VALUES (75, 'admin', 1, 'Admin/file/upload', '上传控件', -1, '');
INSERT INTO `pb_auth_rule` VALUES (76, 'admin', 1, 'Admin/file/uploadPicture', '上传图片', -1, '');
INSERT INTO `pb_auth_rule` VALUES (77, 'admin', 1, 'Admin/file/download', '下载', -1, '');
INSERT INTO `pb_auth_rule` VALUES (94, 'admin', 1, 'Admin/AuthManager/modelauth', '模型授权', -1, '');
INSERT INTO `pb_auth_rule` VALUES (79, 'admin', 1, 'Admin/article/batchOperate', '导入', -1, '');
INSERT INTO `pb_auth_rule` VALUES (80, 'admin', 1, 'Admin/Database/index?type=export', '备份数据库', -1, '');
INSERT INTO `pb_auth_rule` VALUES (81, 'admin', 1, 'Admin/Database/index?type=import', '还原数据库', -1, '');
INSERT INTO `pb_auth_rule` VALUES (82, 'admin', 1, 'admin/Database/export', '备份', 1, '');
INSERT INTO `pb_auth_rule` VALUES (83, 'admin', 1, 'admin/Database/optimize', '优化表', 1, '');
INSERT INTO `pb_auth_rule` VALUES (84, 'admin', 1, 'admin/Database/repair', '修复表', 1, '');
INSERT INTO `pb_auth_rule` VALUES (86, 'admin', 1, 'admin/Database/import', '恢复', 1, '');
INSERT INTO `pb_auth_rule` VALUES (87, 'admin', 1, 'admin/Database/del', '删除', 1, '');
INSERT INTO `pb_auth_rule` VALUES (88, 'admin', 1, 'admin/User/add', '新增', 1, '');
INSERT INTO `pb_auth_rule` VALUES (89, 'admin', 1, 'Admin/Attribute/index', '属性管理', -1, '');
INSERT INTO `pb_auth_rule` VALUES (90, 'admin', 1, 'Admin/Attribute/add', '新增', -1, '');
INSERT INTO `pb_auth_rule` VALUES (91, 'admin', 1, 'Admin/Attribute/edit', '编辑', -1, '');
INSERT INTO `pb_auth_rule` VALUES (92, 'admin', 1, 'Admin/Attribute/setStatus', '改变状态', -1, '');
INSERT INTO `pb_auth_rule` VALUES (93, 'admin', 1, 'Admin/Attribute/update', '保存数据', -1, '');
INSERT INTO `pb_auth_rule` VALUES (95, 'admin', 1, 'Admin/AuthManager/addToModel', '保存模型授权', -1, '');
INSERT INTO `pb_auth_rule` VALUES (96, 'admin', 1, 'Admin/Category/move', '移动', -1, '');
INSERT INTO `pb_auth_rule` VALUES (97, 'admin', 1, 'Admin/Category/merge', '合并', -1, '');
INSERT INTO `pb_auth_rule` VALUES (98, 'admin', 1, 'Admin/Config/menu', '后台菜单管理', -1, '');
INSERT INTO `pb_auth_rule` VALUES (99, 'admin', 1, 'Admin/Article/mydocument', '内容', -1, '');
INSERT INTO `pb_auth_rule` VALUES (100, 'admin', 1, 'admin/Menu/index', '菜单管理', 1, '');
INSERT INTO `pb_auth_rule` VALUES (101, 'admin', 1, 'Admin/other', '其他', -1, '');
INSERT INTO `pb_auth_rule` VALUES (102, 'admin', 1, 'admin/Menu/add', '新增', 1, '');
INSERT INTO `pb_auth_rule` VALUES (103, 'admin', 1, 'admin/Menu/edit', '编辑', 1, '');
INSERT INTO `pb_auth_rule` VALUES (104, 'admin', 1, 'Admin/Think/lists?model=article', '文章管理', -1, '');
INSERT INTO `pb_auth_rule` VALUES (105, 'admin', 1, 'Admin/Think/lists?model=download', '下载管理', -1, '');
INSERT INTO `pb_auth_rule` VALUES (106, 'admin', 1, 'Admin/Think/lists?model=config', '配置管理', -1, '');
INSERT INTO `pb_auth_rule` VALUES (107, 'admin', 1, 'admin/Action/actionlog', '行为日志', 1, '');
INSERT INTO `pb_auth_rule` VALUES (108, 'admin', 1, 'Admin/User/updatePassword', '修改密码', -1, '');
INSERT INTO `pb_auth_rule` VALUES (109, 'admin', 1, 'Admin/User/updateNickname', '修改昵称', -1, '');
INSERT INTO `pb_auth_rule` VALUES (110, 'admin', 1, 'Admin/action/edit', '查看行为日志', -1, '');
INSERT INTO `pb_auth_rule` VALUES (205, 'admin', 1, 'Admin/think/add', '新增数据', -1, '');
INSERT INTO `pb_auth_rule` VALUES (111, 'admin', 2, 'Admin/article/index', '文档列表', -1, '');
INSERT INTO `pb_auth_rule` VALUES (112, 'admin', 2, 'Admin/article/add', '新增', -1, '');
INSERT INTO `pb_auth_rule` VALUES (113, 'admin', 2, 'Admin/article/edit', '编辑', -1, '');
INSERT INTO `pb_auth_rule` VALUES (114, 'admin', 2, 'Admin/article/setStatus', '改变状态', -1, '');
INSERT INTO `pb_auth_rule` VALUES (115, 'admin', 2, 'Admin/article/update', '保存', -1, '');
INSERT INTO `pb_auth_rule` VALUES (116, 'admin', 2, 'Admin/article/autoSave', '保存草稿', -1, '');
INSERT INTO `pb_auth_rule` VALUES (117, 'admin', 2, 'Admin/article/move', '移动', -1, '');
INSERT INTO `pb_auth_rule` VALUES (118, 'admin', 2, 'Admin/article/copy', '复制', -1, '');
INSERT INTO `pb_auth_rule` VALUES (119, 'admin', 2, 'Admin/article/paste', '粘贴', -1, '');
INSERT INTO `pb_auth_rule` VALUES (120, 'admin', 2, 'Admin/article/batchOperate', '导入', -1, '');
INSERT INTO `pb_auth_rule` VALUES (121, 'admin', 2, 'Admin/article/recycle', '回收站', -1, '');
INSERT INTO `pb_auth_rule` VALUES (122, 'admin', 2, 'Admin/article/permit', '还原', -1, '');
INSERT INTO `pb_auth_rule` VALUES (123, 'admin', 2, 'Admin/article/clear', '清空', -1, '');
INSERT INTO `pb_auth_rule` VALUES (124, 'admin', 2, 'Admin/User/add', '新增用户', -1, '');
INSERT INTO `pb_auth_rule` VALUES (125, 'admin', 2, 'Admin/User/action', '用户行为', -1, '');
INSERT INTO `pb_auth_rule` VALUES (126, 'admin', 2, 'Admin/User/addAction', '新增用户行为', -1, '');
INSERT INTO `pb_auth_rule` VALUES (127, 'admin', 2, 'Admin/User/editAction', '编辑用户行为', -1, '');
INSERT INTO `pb_auth_rule` VALUES (128, 'admin', 2, 'Admin/User/saveAction', '保存用户行为', -1, '');
INSERT INTO `pb_auth_rule` VALUES (129, 'admin', 2, 'Admin/User/setStatus', '变更行为状态', -1, '');
INSERT INTO `pb_auth_rule` VALUES (130, 'admin', 2, 'Admin/User/changeStatus?method=forbidUser', '禁用会员', -1, '');
INSERT INTO `pb_auth_rule` VALUES (131, 'admin', 2, 'Admin/User/changeStatus?method=resumeUser', '启用会员', -1, '');
INSERT INTO `pb_auth_rule` VALUES (132, 'admin', 2, 'Admin/User/changeStatus?method=deleteUser', '删除会员', -1, '');
INSERT INTO `pb_auth_rule` VALUES (133, 'admin', 2, 'Admin/AuthManager/index', '权限管理', -1, '');
INSERT INTO `pb_auth_rule` VALUES (134, 'admin', 2, 'Admin/AuthManager/changeStatus?method=deleteGroup', '删除', -1, '');
INSERT INTO `pb_auth_rule` VALUES (135, 'admin', 2, 'Admin/AuthManager/changeStatus?method=forbidGroup', '禁用', -1, '');
INSERT INTO `pb_auth_rule` VALUES (136, 'admin', 2, 'Admin/AuthManager/changeStatus?method=resumeGroup', '恢复', -1, '');
INSERT INTO `pb_auth_rule` VALUES (137, 'admin', 2, 'Admin/AuthManager/createGroup', '新增', -1, '');
INSERT INTO `pb_auth_rule` VALUES (138, 'admin', 2, 'Admin/AuthManager/editGroup', '编辑', -1, '');
INSERT INTO `pb_auth_rule` VALUES (139, 'admin', 2, 'Admin/AuthManager/writeGroup', '保存用户组', -1, '');
INSERT INTO `pb_auth_rule` VALUES (140, 'admin', 2, 'Admin/AuthManager/group', '授权', -1, '');
INSERT INTO `pb_auth_rule` VALUES (141, 'admin', 2, 'Admin/AuthManager/access', '访问授权', -1, '');
INSERT INTO `pb_auth_rule` VALUES (142, 'admin', 2, 'Admin/AuthManager/user', '成员授权', -1, '');
INSERT INTO `pb_auth_rule` VALUES (143, 'admin', 2, 'Admin/AuthManager/removeFromGroup', '解除授权', -1, '');
INSERT INTO `pb_auth_rule` VALUES (144, 'admin', 2, 'Admin/AuthManager/addToGroup', '保存成员授权', -1, '');
INSERT INTO `pb_auth_rule` VALUES (145, 'admin', 2, 'Admin/AuthManager/category', '分类授权', -1, '');
INSERT INTO `pb_auth_rule` VALUES (146, 'admin', 2, 'Admin/AuthManager/addToCategory', '保存分类授权', -1, '');
INSERT INTO `pb_auth_rule` VALUES (147, 'admin', 2, 'Admin/AuthManager/modelauth', '模型授权', -1, '');
INSERT INTO `pb_auth_rule` VALUES (148, 'admin', 2, 'Admin/AuthManager/addToModel', '保存模型授权', -1, '');
INSERT INTO `pb_auth_rule` VALUES (149, 'admin', 2, 'Admin/Addons/create', '创建', -1, '');
INSERT INTO `pb_auth_rule` VALUES (150, 'admin', 2, 'Admin/Addons/checkForm', '检测创建', -1, '');
INSERT INTO `pb_auth_rule` VALUES (151, 'admin', 2, 'Admin/Addons/preview', '预览', -1, '');
INSERT INTO `pb_auth_rule` VALUES (152, 'admin', 2, 'Admin/Addons/build', '快速生成插件', -1, '');
INSERT INTO `pb_auth_rule` VALUES (153, 'admin', 2, 'Admin/Addons/config', '设置', -1, '');
INSERT INTO `pb_auth_rule` VALUES (154, 'admin', 2, 'Admin/Addons/disable', '禁用', -1, '');
INSERT INTO `pb_auth_rule` VALUES (155, 'admin', 2, 'Admin/Addons/enable', '启用', -1, '');
INSERT INTO `pb_auth_rule` VALUES (156, 'admin', 2, 'Admin/Addons/install', '安装', -1, '');
INSERT INTO `pb_auth_rule` VALUES (157, 'admin', 2, 'Admin/Addons/uninstall', '卸载', -1, '');
INSERT INTO `pb_auth_rule` VALUES (158, 'admin', 2, 'Admin/Addons/saveconfig', '更新配置', -1, '');
INSERT INTO `pb_auth_rule` VALUES (159, 'admin', 2, 'Admin/Addons/adminList', '插件后台列表', -1, '');
INSERT INTO `pb_auth_rule` VALUES (160, 'admin', 2, 'Admin/Addons/execute', 'URL方式访问插件', -1, '');
INSERT INTO `pb_auth_rule` VALUES (161, 'admin', 2, 'Admin/Addons/hooks', '钩子管理', -1, '');
INSERT INTO `pb_auth_rule` VALUES (162, 'admin', 2, 'Admin/Model/index', '模型管理', -1, '');
INSERT INTO `pb_auth_rule` VALUES (163, 'admin', 2, 'Admin/model/add', '新增', -1, '');
INSERT INTO `pb_auth_rule` VALUES (164, 'admin', 2, 'Admin/model/edit', '编辑', -1, '');
INSERT INTO `pb_auth_rule` VALUES (165, 'admin', 2, 'Admin/model/setStatus', '改变状态', -1, '');
INSERT INTO `pb_auth_rule` VALUES (166, 'admin', 2, 'Admin/model/update', '保存数据', -1, '');
INSERT INTO `pb_auth_rule` VALUES (167, 'admin', 2, 'Admin/Attribute/index', '属性管理', -1, '');
INSERT INTO `pb_auth_rule` VALUES (168, 'admin', 2, 'Admin/Attribute/add', '新增', -1, '');
INSERT INTO `pb_auth_rule` VALUES (169, 'admin', 2, 'Admin/Attribute/edit', '编辑', -1, '');
INSERT INTO `pb_auth_rule` VALUES (170, 'admin', 2, 'Admin/Attribute/setStatus', '改变状态', -1, '');
INSERT INTO `pb_auth_rule` VALUES (171, 'admin', 2, 'Admin/Attribute/update', '保存数据', -1, '');
INSERT INTO `pb_auth_rule` VALUES (172, 'admin', 2, 'Admin/Config/index', '配置管理', -1, '');
INSERT INTO `pb_auth_rule` VALUES (173, 'admin', 2, 'Admin/Config/edit', '编辑', -1, '');
INSERT INTO `pb_auth_rule` VALUES (174, 'admin', 2, 'Admin/Config/del', '删除', -1, '');
INSERT INTO `pb_auth_rule` VALUES (175, 'admin', 2, 'Admin/Config/add', '新增', -1, '');
INSERT INTO `pb_auth_rule` VALUES (176, 'admin', 2, 'Admin/Config/save', '保存', -1, '');
INSERT INTO `pb_auth_rule` VALUES (177, 'admin', 2, 'Admin/Menu/index', '菜单管理', -1, '');
INSERT INTO `pb_auth_rule` VALUES (178, 'admin', 2, 'Admin/Channel/index', '导航管理', -1, '');
INSERT INTO `pb_auth_rule` VALUES (179, 'admin', 2, 'Admin/Channel/add', '新增', -1, '');
INSERT INTO `pb_auth_rule` VALUES (180, 'admin', 2, 'Admin/Channel/edit', '编辑', -1, '');
INSERT INTO `pb_auth_rule` VALUES (181, 'admin', 2, 'Admin/Channel/del', '删除', -1, '');
INSERT INTO `pb_auth_rule` VALUES (182, 'admin', 2, 'Admin/Category/index', '分类管理', -1, '');
INSERT INTO `pb_auth_rule` VALUES (183, 'admin', 2, 'Admin/Category/edit', '编辑', -1, '');
INSERT INTO `pb_auth_rule` VALUES (184, 'admin', 2, 'Admin/Category/add', '新增', -1, '');
INSERT INTO `pb_auth_rule` VALUES (185, 'admin', 2, 'Admin/Category/remove', '删除', -1, '');
INSERT INTO `pb_auth_rule` VALUES (186, 'admin', 2, 'Admin/Category/move', '移动', -1, '');
INSERT INTO `pb_auth_rule` VALUES (187, 'admin', 2, 'Admin/Category/merge', '合并', -1, '');
INSERT INTO `pb_auth_rule` VALUES (188, 'admin', 2, 'Admin/Database/index?type=export', '备份数据库', -1, '');
INSERT INTO `pb_auth_rule` VALUES (189, 'admin', 2, 'Admin/Database/export', '备份', -1, '');
INSERT INTO `pb_auth_rule` VALUES (190, 'admin', 2, 'Admin/Database/optimize', '优化表', -1, '');
INSERT INTO `pb_auth_rule` VALUES (191, 'admin', 2, 'Admin/Database/repair', '修复表', -1, '');
INSERT INTO `pb_auth_rule` VALUES (192, 'admin', 2, 'Admin/Database/index?type=import', '还原数据库', -1, '');
INSERT INTO `pb_auth_rule` VALUES (193, 'admin', 2, 'Admin/Database/import', '恢复', -1, '');
INSERT INTO `pb_auth_rule` VALUES (194, 'admin', 2, 'Admin/Database/del', '删除', -1, '');
INSERT INTO `pb_auth_rule` VALUES (195, 'admin', 2, 'Admin/other', '其他', -1, '');
INSERT INTO `pb_auth_rule` VALUES (196, 'admin', 2, 'Admin/Menu/add', '新增', -1, '');
INSERT INTO `pb_auth_rule` VALUES (197, 'admin', 2, 'Admin/Menu/edit', '编辑', -1, '');
INSERT INTO `pb_auth_rule` VALUES (198, 'admin', 2, 'Admin/Think/lists?model=article', '应用', -1, '');
INSERT INTO `pb_auth_rule` VALUES (199, 'admin', 2, 'Admin/Think/lists?model=download', '下载管理', -1, '');
INSERT INTO `pb_auth_rule` VALUES (200, 'admin', 2, 'Admin/Think/lists?model=config', '应用', -1, '');
INSERT INTO `pb_auth_rule` VALUES (201, 'admin', 2, 'Admin/Action/actionlog', '行为日志', -1, '');
INSERT INTO `pb_auth_rule` VALUES (202, 'admin', 2, 'Admin/User/updatePassword', '修改密码', -1, '');
INSERT INTO `pb_auth_rule` VALUES (203, 'admin', 2, 'Admin/User/updateNickname', '修改昵称', -1, '');
INSERT INTO `pb_auth_rule` VALUES (204, 'admin', 2, 'Admin/action/edit', '查看行为日志', -1, '');
INSERT INTO `pb_auth_rule` VALUES (206, 'admin', 1, 'Admin/think/edit', '编辑数据', -1, '');
INSERT INTO `pb_auth_rule` VALUES (207, 'admin', 1, 'admin/Menu/import', '导入	', 1, '');
INSERT INTO `pb_auth_rule` VALUES (208, 'admin', 1, 'Admin/Model/generate', '生成', -1, '');
INSERT INTO `pb_auth_rule` VALUES (209, 'admin', 1, 'Admin/Addons/addHook', '新增钩子', -1, '');
INSERT INTO `pb_auth_rule` VALUES (210, 'admin', 1, 'Admin/Addons/edithook', '编辑钩子', -1, '');
INSERT INTO `pb_auth_rule` VALUES (211, 'admin', 1, 'Admin/Article/sort', '文档排序', -1, '');
INSERT INTO `pb_auth_rule` VALUES (212, 'admin', 1, 'admin/Config/sort', '排序', 1, '');
INSERT INTO `pb_auth_rule` VALUES (213, 'admin', 1, 'admin/Menu/sort', '排序', 1, '');
INSERT INTO `pb_auth_rule` VALUES (214, 'admin', 1, 'Admin/Channel/sort', '排序', -1, '');
INSERT INTO `pb_auth_rule` VALUES (215, 'admin', 1, 'Admin/Category/operate/type/move', '移动', -1, '');
INSERT INTO `pb_auth_rule` VALUES (216, 'admin', 1, 'Admin/Category/operate/type/merge', '合并', -1, '');
INSERT INTO `pb_auth_rule` VALUES (217, 'admin', 1, 'Admin/article/index', '文档列表', -1, '');
INSERT INTO `pb_auth_rule` VALUES (218, 'admin', 1, 'Admin/think/lists', '数据列表', -1, '');
INSERT INTO `pb_auth_rule` VALUES (219, 'admin', 1, 'admin/Menu/del', '删除', 1, '');
INSERT INTO `pb_auth_rule` VALUES (220, 'admin', 1, 'admin/Menu/toogleHide', '设置隐藏', 1, '');
INSERT INTO `pb_auth_rule` VALUES (221, 'admin', 1, 'admin/Menu/toogleDev', '设置开发者', 1, '');
INSERT INTO `pb_auth_rule` VALUES (222, 'admin', 1, 'admin/Menu/getinfo', '获取信息', 1, '');
INSERT INTO `pb_auth_rule` VALUES (223, 'admin', 1, 'admin/Auth/index', '权限管理', 1, '');
INSERT INTO `pb_auth_rule` VALUES (224, 'admin', 1, 'admin/User/edit', '编辑', 1, '');
INSERT INTO `pb_auth_rule` VALUES (225, 'admin', 1, 'admin/User/del', '删除', 1, '');
INSERT INTO `pb_auth_rule` VALUES (226, 'admin', 1, 'admin/User/changeStatus', '修改状态', 1, '');
INSERT INTO `pb_auth_rule` VALUES (227, 'admin', 1, 'admin/User/delaction', '删除', 1, '');
INSERT INTO `pb_auth_rule` VALUES (228, 'admin', 1, 'admin/Auth/add', '新增', 1, '');
INSERT INTO `pb_auth_rule` VALUES (229, 'admin', 1, 'admin/Auth/edit', '编辑', 1, '');
INSERT INTO `pb_auth_rule` VALUES (230, 'admin', 1, 'admin/Auth/del', '删除', 1, '');
INSERT INTO `pb_auth_rule` VALUES (231, 'admin', 1, 'admin/Auth/changeStatus', '修改状态', 1, '');
INSERT INTO `pb_auth_rule` VALUES (232, 'admin', 1, 'admin/Auth/user', '成员授权', 1, '');
INSERT INTO `pb_auth_rule` VALUES (233, 'admin', 1, 'admin/Auth/access', '访问授权', 1, '');
INSERT INTO `pb_auth_rule` VALUES (234, 'admin', 1, 'admin/Auth/group', '组授权', 1, '');
INSERT INTO `pb_auth_rule` VALUES (235, 'admin', 1, 'admin/Auth/addToGroup', '保存成员授权', 1, '');
INSERT INTO `pb_auth_rule` VALUES (236, 'admin', 1, 'admin/Auth/removeFromGroup', '解除授权', 1, '');
INSERT INTO `pb_auth_rule` VALUES (237, 'admin', 1, 'admin/action/view', '查看行为日志', 1, '');
INSERT INTO `pb_auth_rule` VALUES (238, 'admin', 1, 'admin/Wechat/user', '用户列表', 1, '');
INSERT INTO `pb_auth_rule` VALUES (239, 'admin', 1, 'admin/Wechat/department', '部门', 1, '');
INSERT INTO `pb_auth_rule` VALUES (240, 'admin', 1, 'admin/Wechat/tag', '标签', 1, '');
INSERT INTO `pb_auth_rule` VALUES (241, 'admin', 1, 'admin/Wechat/synchronize', '同步通讯录', 1, '');
INSERT INTO `pb_auth_rule` VALUES (265, 'admin', 2, 'admin/Wechat/index', '通讯录', 1, '');
INSERT INTO `pb_auth_rule` VALUES (266, 'admin', 2, 'admin/System/index', '系统设置', 1, '');
INSERT INTO `pb_auth_rule` VALUES (398, 'admin', 1, 'admin/Index/editpassword', '修改密码', 1, '');
COMMIT;

-- ----------------------------
-- Table structure for pb_comment
-- ----------------------------
DROP TABLE IF EXISTS `pb_comment`;
CREATE TABLE `pb_comment` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `content` text COMMENT '评论内容',
  `type` tinyint(4) DEFAULT NULL COMMENT '评论类型，1第一聚焦 2支部活动 3两学一做 4意见反馈 5红色电影 6红色歌曲 7经典书籍 13党员之声  14文明创建',
  `table` varchar(50) DEFAULT NULL COMMENT '表名',
  `aid` int(11) DEFAULT NULL COMMENT '文章id',
  `uid` varchar(255) DEFAULT NULL COMMENT '用户id',
  `comments` mediumint(9) DEFAULT '0' COMMENT '评论数',
  `likes` mediumint(9) DEFAULT '0' COMMENT '点赞数',
  `create_time` int(11) DEFAULT NULL COMMENT '评论时间',
  `status` tinyint(4) DEFAULT '0' COMMENT '-1 删除 0正常',
  `score` int(11) DEFAULT '1' COMMENT '得分标准，评论1分',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='用户评论表';

-- ----------------------------
-- Table structure for pb_config
-- ----------------------------
DROP TABLE IF EXISTS `pb_config`;
CREATE TABLE `pb_config` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '配置ID',
  `name` varchar(30) NOT NULL DEFAULT '' COMMENT '配置名称',
  `type` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '配置类型',
  `title` varchar(50) NOT NULL DEFAULT '' COMMENT '配置说明',
  `group` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '配置分组',
  `extra` varchar(255) NOT NULL DEFAULT '' COMMENT '配置值',
  `remark` varchar(100) NOT NULL DEFAULT '' COMMENT '配置说明',
  `create_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '创建时间',
  `update_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '更新时间',
  `status` tinyint(4) NOT NULL DEFAULT '0' COMMENT '状态',
  `value` text COMMENT '配置值',
  `sort` smallint(3) unsigned NOT NULL DEFAULT '0' COMMENT '排序',
  PRIMARY KEY (`id`),
  UNIQUE KEY `uk_name` (`name`) USING BTREE,
  KEY `type` (`type`) USING BTREE,
  KEY `group` (`group`) USING BTREE
) ENGINE=MyISAM AUTO_INCREMENT=38 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of pb_config
-- ----------------------------
BEGIN;
INSERT INTO `pb_config` VALUES (1, 'WEB_SITE_TITLE', 1, '网站标题', 1, '', '网站标题前台显示标题', 1378898976, 1379235274, 1, '智慧党建', 0);
INSERT INTO `pb_config` VALUES (2, 'WEB_SITE_DESCRIPTION', 2, '网站描述', 1, '', '网站搜索引擎描述', 1378898976, 1379235841, 1, '机关党建', 1);
INSERT INTO `pb_config` VALUES (3, 'WEB_SITE_KEYWORD', 2, '网站关键字', 1, '', '网站搜索引擎关键字', 1378898976, 1381390100, 1, '机关党建,共产党,', 8);
INSERT INTO `pb_config` VALUES (4, 'WEB_SITE_CLOSE', 4, '关闭站点', 1, '0:关闭,1:开启', '站点关闭后其他用户不能访问，管理员可以正常访问', 1378898976, 1379235296, 1, '1', 1);
INSERT INTO `pb_config` VALUES (9, 'CONFIG_TYPE_LIST', 3, '配置类型列表', 4, '', '主要用于数据解析和页面表单的生成', 1378898976, 1379235348, 1, '0:数字\r\n1:字符\r\n2:文本\r\n3:数组\r\n4:枚举', 2);
INSERT INTO `pb_config` VALUES (10, 'WEB_SITE_ICP', 1, '网站备案号', 1, '', '设置在网站底部显示的备案号，如“沪ICP备12007941号-2', 1378900335, 1379235859, 1, '', 9);
INSERT INTO `pb_config` VALUES (11, 'DOCUMENT_POSITION', 3, '文档推荐位', 2, '', '文档推荐位，推荐到多个位置KEY值相加即可', 1379053380, 1379235329, 1, '1:列表推荐\r\n2:频道推荐\r\n4:首页推荐', 3);
INSERT INTO `pb_config` VALUES (12, 'DOCUMENT_DISPLAY', 3, '文档可见性', 2, '', '文章可见性仅影响前台显示，后台不收影响', 1379056370, 1379235322, 1, '0:所有人可见\r\n1:仅注册会员可见\r\n2:仅管理员可见', 4);
INSERT INTO `pb_config` VALUES (13, 'COLOR_STYLE', 4, '后台色系', 1, 'default_color:默认\r\nblue_color:紫罗兰', '后台颜色风格', 1379122533, 1379235904, 1, 'default_color', 10);
INSERT INTO `pb_config` VALUES (20, 'CONFIG_GROUP_LIST', 3, '配置分组', 4, '', '配置分组', 1379228036, 1384418383, 1, '1:基本\r\n2:内容\r\n3:用户\r\n4:系统', 4);
INSERT INTO `pb_config` VALUES (21, 'HOOKS_TYPE', 3, '钩子的类型', 4, '', '类型 1-用于扩展显示内容，2-用于扩展业务处理', 1379313397, 1379313407, 1, '1:视图\r\n2:控制器', 6);
INSERT INTO `pb_config` VALUES (22, 'AUTH_CONFIG', 3, 'Auth配置', 4, '', '自定义Auth.class.php类配置', 1379409310, 1379409564, 1, 'AUTH_ON:1\r\nAUTH_TYPE:2', 8);
INSERT INTO `pb_config` VALUES (23, 'OPEN_DRAFTBOX', 4, '是否开启草稿功能', 2, '0:关闭草稿功能\r\n1:开启草稿功能\r\n', '新增文章时的草稿功能配置', 1379484332, 1379484591, 1, '1', 1);
INSERT INTO `pb_config` VALUES (24, 'DRAFT_AOTOSAVE_INTERVAL', 0, '自动保存草稿时间', 2, '', '自动保存草稿的时间间隔，单位：秒', 1379484574, 1386143323, 1, '60', 2);
INSERT INTO `pb_config` VALUES (25, 'LIST_ROWS', 0, '后台每页记录数', 2, '', '后台数据每页显示记录数', 1379503896, 1380427745, 1, '10', 10);
INSERT INTO `pb_config` VALUES (26, 'USER_ALLOW_REGISTER', 4, '是否允许用户注册', 3, '0:关闭注册\r\n1:允许注册', '是否开放用户注册', 1379504487, 1379504580, 1, '1', 3);
INSERT INTO `pb_config` VALUES (27, 'CODEMIRROR_THEME', 4, '预览插件的CodeMirror主题', 4, '3024-day:3024 day\r\n3024-night:3024 night\r\nambiance:ambiance\r\nbase16-dark:base16 dark\r\nbase16-light:base16 light\r\nblackboard:blackboard\r\ncobalt:cobalt\r\neclipse:eclipse\r\nelegant:elegant\r\nerlang-dark:erlang-dark\r\nlesser-dark:lesser-dark\r\nmidnight:midnight', '详情见CodeMirror官网', 1379814385, 1384740813, 1, 'ambiance', 3);
INSERT INTO `pb_config` VALUES (28, 'DATA_BACKUP_PATH', 1, '数据库备份根路径', 4, '', '路径必须以 / 结尾', 1381482411, 1381482411, 1, './Data/', 5);
INSERT INTO `pb_config` VALUES (29, 'DATA_BACKUP_PART_SIZE', 0, '数据库备份卷大小', 4, '', '该值用于限制压缩后的分卷最大长度。单位：B；建议设置20M', 1381482488, 1381729564, 1, '20971520', 7);
INSERT INTO `pb_config` VALUES (30, 'DATA_BACKUP_COMPRESS', 4, '数据库备份文件是否启用压缩', 4, '0:不压缩\r\n1:启用压缩', '压缩备份文件需要PHP环境支持gzopen,gzwrite函数', 1381713345, 1381729544, 1, '1', 9);
INSERT INTO `pb_config` VALUES (31, 'DATA_BACKUP_COMPRESS_LEVEL', 4, '数据库备份文件压缩级别', 4, '1:普通\r\n4:一般\r\n9:最高', '数据库备份文件的压缩级别，该配置在开启压缩时生效', 1381713408, 1381713408, 1, '9', 10);
INSERT INTO `pb_config` VALUES (32, 'DEVELOP_MODE', 4, '开启开发者模式', 4, '0:关闭\r\n1:开启', '是否开启开发者模式', 1383105995, 1383291877, 1, '1', 11);
INSERT INTO `pb_config` VALUES (33, 'ALLOW_VISIT', 3, '不受限控制器方法', 0, '', '', 1386644047, 1386644741, 1, '0:article/draftbox\r\n1:article/mydocument\r\n2:Category/tree\r\n3:Index/verify\r\n4:file/upload\r\n5:file/download\r\n6:user/updatePassword\r\n7:user/updateNickname\r\n8:user/submitPassword\r\n9:user/submitNickname\r\n10:file/uploadpicture', 0);
INSERT INTO `pb_config` VALUES (34, 'DENY_VISIT', 3, '超管专限控制器方法', 0, '', '仅超级管理员可访问的控制器方法', 1386644141, 1386644659, 1, '0:Addons/addhook\r\n1:Addons/edithook\r\n2:Addons/delhook\r\n3:Addons/updateHook\r\n4:Admin/getMenus\r\n5:Admin/recordList\r\n6:AuthManager/updateRules\r\n7:AuthManager/tree', 0);
INSERT INTO `pb_config` VALUES (35, 'REPLY_LIST_ROWS', 0, '回复列表每页条数', 2, '', '', 1386645376, 1387178083, 1, '10', 0);
INSERT INTO `pb_config` VALUES (36, 'ADMIN_ALLOW_IP', 2, '后台允许访问IP', 4, '', '多个用逗号分隔，如果不配置表示不限制IP访问', 1387165454, 1387165553, 1, '', 12);
INSERT INTO `pb_config` VALUES (37, 'SHOW_PAGE_TRACE', 4, '是否显示页面Trace', 4, '0:关闭\r\n1:开启', '是否显示页面Trace信息', 1387165685, 1387165685, 1, '0', 1);
COMMIT;

-- ----------------------------
-- Table structure for pb_file
-- ----------------------------
DROP TABLE IF EXISTS `pb_file`;
CREATE TABLE `pb_file` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '文件ID',
  `name` varchar(100) NOT NULL DEFAULT '' COMMENT '原始文件名',
  `savename` varchar(100) NOT NULL DEFAULT '' COMMENT '保存名称',
  `savepath` char(30) NOT NULL DEFAULT '' COMMENT '文件保存路径',
  `ext` char(5) NOT NULL DEFAULT '' COMMENT '文件后缀',
  `type` char(40) NOT NULL DEFAULT '' COMMENT '文件mime类型',
  `size` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '文件大小',
  `md5` char(32) NOT NULL DEFAULT '' COMMENT '文件md5',
  `sha1` char(40) NOT NULL DEFAULT '' COMMENT '文件 sha1编码',
  `location` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '文件保存位置',
  `url` varchar(255) NOT NULL DEFAULT '' COMMENT '远程地址',
  `create_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '上传时间',
  PRIMARY KEY (`id`),
  UNIQUE KEY `uk_md5` (`md5`) USING BTREE
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='文件表';

-- ----------------------------
-- Table structure for pb_member
-- ----------------------------
DROP TABLE IF EXISTS `pb_member`;
CREATE TABLE `pb_member` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '用户ID',
  `nickname` char(16) NOT NULL DEFAULT '' COMMENT '昵称',
  `sex` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '性别',
  `birthday` date DEFAULT NULL COMMENT '生日',
  `qq` char(10) NOT NULL DEFAULT '' COMMENT 'qq号',
  `score` mediumint(8) NOT NULL DEFAULT '0' COMMENT '用户积分',
  `login_total` int(11) DEFAULT NULL,
  `status` tinyint(4) NOT NULL DEFAULT '1' COMMENT '会员状态',
  `reg_time` int(11) DEFAULT NULL,
  `reg_ip` bigint(20) DEFAULT NULL,
  `last_login_time` int(11) DEFAULT NULL,
  `last_login_ip` bigint(20) DEFAULT NULL,
  `check_number` varchar(11) DEFAULT NULL,
  `active_time` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `status` (`status`) USING BTREE
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COMMENT='会员表';

-- ----------------------------
-- Records of pb_member
-- ----------------------------
BEGIN;
INSERT INTO `pb_member` VALUES (1, 'admin', 0, NULL, '', 0, 1, 1, NULL, NULL, 1541142058, 2130706433, '6vxpn336yx', 1493109131);
INSERT INTO `pb_member` VALUES (2, 'test', 0, NULL, '', 0, NULL, 1, NULL, NULL, 1517386228, 2130706433, NULL, NULL);
COMMIT;

-- ----------------------------
-- Table structure for pb_menu
-- ----------------------------
DROP TABLE IF EXISTS `pb_menu`;
CREATE TABLE `pb_menu` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '文档ID',
  `title` varchar(50) NOT NULL DEFAULT '' COMMENT '标题',
  `icon` varchar(50) DEFAULT NULL,
  `pid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '上级分类ID',
  `sort` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '排序（同级有效）',
  `url` char(255) NOT NULL DEFAULT '' COMMENT '链接地址',
  `hide` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否隐藏',
  `tip` varchar(255) NOT NULL DEFAULT '' COMMENT '提示',
  `group` varchar(50) DEFAULT '' COMMENT '分组',
  `is_dev` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否仅开发者模式可见',
  `status` tinyint(1) NOT NULL DEFAULT '0' COMMENT '状态',
  PRIMARY KEY (`id`),
  KEY `pid` (`pid`) USING BTREE,
  KEY `status` (`status`) USING BTREE
) ENGINE=MyISAM AUTO_INCREMENT=282 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of pb_menu
-- ----------------------------
BEGIN;
INSERT INTO `pb_menu` VALUES (281, '修改密码', '', 5, 0, 'Index/editpassword', 1, '', '', 0, 1);
INSERT INTO `pb_menu` VALUES (5, '通讯录', 'fa-users', 0, 98, 'Wechat/index', 0, '', '', 0, 1);
INSERT INTO `pb_menu` VALUES (6, '系统设置', 'fa-cog', 0, 99, 'System/index', 0, '', '', 0, 1);
INSERT INTO `pb_menu` VALUES (7, '网站配置', '', 6, 0, 'Config/group', 0, '', '', 0, 1);
INSERT INTO `pb_menu` VALUES (8, '配置属性', '', 6, 0, 'Config/index', 1, '', '', 0, 1);
INSERT INTO `pb_menu` VALUES (9, '菜单管理', '', 6, 0, 'Menu/index', 0, '', '', 0, 1);
INSERT INTO `pb_menu` VALUES (10, '备份数据库', '', 6, 0, 'Database/export', 1, '', '', 0, 1);
INSERT INTO `pb_menu` VALUES (11, '还原数据库', '', 6, 0, 'Database/import', 1, '', '', 0, 1);
INSERT INTO `pb_menu` VALUES (12, '新增', '', 8, 0, 'Config/add', 0, '', '', 0, 1);
INSERT INTO `pb_menu` VALUES (13, '编辑', '', 8, 0, 'Config/edit', 0, '', '', 0, 1);
INSERT INTO `pb_menu` VALUES (14, '删除', '', 8, 0, 'Config/del', 0, '', '', 0, 1);
INSERT INTO `pb_menu` VALUES (15, '保存', '', 8, 0, 'Config/save', 0, '', '', 0, 1);
INSERT INTO `pb_menu` VALUES (16, '排序', '', 8, 0, 'Config/sort', 0, '', '', 0, 1);
INSERT INTO `pb_menu` VALUES (17, '新增', '', 9, 0, 'Menu/add', 0, '', '', 0, 1);
INSERT INTO `pb_menu` VALUES (18, '编辑', '', 9, 0, 'Menu/edit', 0, '', '', 0, 1);
INSERT INTO `pb_menu` VALUES (19, '导入	', '', 9, 0, 'Menu/import', 0, '', '', 0, 1);
INSERT INTO `pb_menu` VALUES (20, '排序', '', 9, 0, 'Menu/sort', 0, '', '', 0, 1);
INSERT INTO `pb_menu` VALUES (21, '删除', '', 9, 0, 'Menu/del', 0, '', '', 0, 1);
INSERT INTO `pb_menu` VALUES (22, '设置隐藏', '', 9, 0, 'Menu/toogleHide', 0, '', '', 0, 1);
INSERT INTO `pb_menu` VALUES (23, '设置开发者', '', 9, 0, 'Menu/toogleDev', 0, '', '', 0, 1);
INSERT INTO `pb_menu` VALUES (24, '获取信息', '', 9, 0, 'Menu/getinfo', 0, '', '', 0, 1);
INSERT INTO `pb_menu` VALUES (25, '后台用户', 'fa-user', 0, 100, 'User/index', 0, '', '', 0, 1);
INSERT INTO `pb_menu` VALUES (26, '用户信息', '', 25, 0, 'User/index', 0, '', '', 0, 1);
INSERT INTO `pb_menu` VALUES (27, '用户行为', '', 25, 0, 'User/action', 1, '', '', 0, 1);
INSERT INTO `pb_menu` VALUES (28, '权限管理', '', 25, 0, 'Auth/index', 0, '', '', 0, 1);
INSERT INTO `pb_menu` VALUES (29, '行为日志', '', 25, 0, 'Action/actionlog', 1, '', '', 0, 1);
INSERT INTO `pb_menu` VALUES (30, '新增', '', 26, 0, 'User/add', 0, '', '', 0, 1);
INSERT INTO `pb_menu` VALUES (31, '编辑', '', 26, 0, 'User/edit', 0, '', '', 0, 1);
INSERT INTO `pb_menu` VALUES (32, '删除', '', 26, 0, 'User/del', 0, '', '', 0, 1);
INSERT INTO `pb_menu` VALUES (33, '修改状态', '', 26, 0, 'User/changeStatus', 0, '', '', 0, 1);
INSERT INTO `pb_menu` VALUES (34, '新增', '', 27, 0, 'User/addaction', 0, '', '', 0, 1);
INSERT INTO `pb_menu` VALUES (35, '编辑', '', 27, 0, 'User/editaction', 0, '', '', 0, 1);
INSERT INTO `pb_menu` VALUES (36, '删除', '', 27, 0, 'User/delaction', 0, '', '', 0, 1);
INSERT INTO `pb_menu` VALUES (37, '变更状态', '', 27, 0, 'User/setStatus', 0, '', '', 0, 1);
INSERT INTO `pb_menu` VALUES (38, '新增', '', 28, 0, 'Auth/add', 0, '', '', 0, 1);
INSERT INTO `pb_menu` VALUES (39, '编辑', '', 28, 0, 'Auth/edit', 0, '', '', 0, 1);
INSERT INTO `pb_menu` VALUES (40, '删除', '', 28, 0, 'Auth/del', 0, '', '', 0, 1);
INSERT INTO `pb_menu` VALUES (41, '修改状态', '', 28, 0, 'Auth/changeStatus', 0, '', '', 0, 1);
INSERT INTO `pb_menu` VALUES (42, '成员授权', '', 28, 0, 'Auth/user', 0, '', '', 0, 1);
INSERT INTO `pb_menu` VALUES (43, '访问授权', '', 28, 0, 'Auth/access', 0, '', '', 0, 1);
INSERT INTO `pb_menu` VALUES (44, '组授权', '', 28, 0, 'Auth/group', 0, '', '', 0, 1);
INSERT INTO `pb_menu` VALUES (45, '保存成员授权', '', 28, 0, 'Auth/addToGroup', 0, '', '', 0, 1);
INSERT INTO `pb_menu` VALUES (46, '解除授权', '', 28, 0, 'Auth/removeFromGroup', 0, '', '', 0, 1);
INSERT INTO `pb_menu` VALUES (47, '查看行为日志', '', 29, 0, 'action/view', 0, '', '', 0, 1);
INSERT INTO `pb_menu` VALUES (48, '备份', '', 10, 0, 'Database/export', 0, '', '', 0, 1);
INSERT INTO `pb_menu` VALUES (49, '优化表', '', 10, 0, 'Database/optimize', 0, '', '', 0, 1);
INSERT INTO `pb_menu` VALUES (50, '修复表', '', 10, 0, 'Database/repair', 0, '', '', 0, 1);
INSERT INTO `pb_menu` VALUES (51, '恢复', '', 11, 0, 'Database/import', 0, '', '', 0, 1);
INSERT INTO `pb_menu` VALUES (52, '删除', '', 11, 0, 'Database/del', 0, '', '', 0, 1);
INSERT INTO `pb_menu` VALUES (53, '用户列表', '', 5, 0, 'Wechat/user', 0, '', '', 0, 1);
INSERT INTO `pb_menu` VALUES (54, '部门', '', 5, 0, 'Wechat/department', 0, '', '', 0, 1);
INSERT INTO `pb_menu` VALUES (55, '标签', '', 5, 0, 'Wechat/tag', 0, '', '', 0, 1);
INSERT INTO `pb_menu` VALUES (56, '同步通讯录', '', 5, 0, 'Wechat/synchronize', 1, '', '', 0, 1);
INSERT INTO `pb_menu` VALUES (200, '首页', 'fa-users', 0, 0, 'Index/index', 0, '', '', 0, 1);
COMMIT;

-- ----------------------------
-- Table structure for pb_picture
-- ----------------------------
DROP TABLE IF EXISTS `pb_picture`;
CREATE TABLE `pb_picture` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键id自增',
  `path` varchar(255) NOT NULL DEFAULT '' COMMENT '路径',
  `url` varchar(255) NOT NULL DEFAULT '' COMMENT '图片链接',
  `md5` char(32) NOT NULL DEFAULT '' COMMENT '文件md5',
  `sha1` char(40) NOT NULL DEFAULT '' COMMENT '文件 sha1编码',
  `status` tinyint(2) NOT NULL DEFAULT '0' COMMENT '状态',
  `create_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '创建时间',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='图片表';

-- ----------------------------
-- Table structure for pb_ucenter_member
-- ----------------------------
DROP TABLE IF EXISTS `pb_ucenter_member`;
CREATE TABLE `pb_ucenter_member` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '用户ID',
  `username` char(16) NOT NULL COMMENT '用户名',
  `password` char(32) NOT NULL COMMENT '密码',
  `email` varchar(100) NOT NULL COMMENT '用户邮箱',
  `mobile` char(15) DEFAULT '' COMMENT '用户手机',
  `login` int(11) DEFAULT '0' COMMENT '登入次数',
  `reg_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '注册时间',
  `reg_ip` bigint(20) NOT NULL DEFAULT '0' COMMENT '注册IP',
  `last_login_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '最后登录时间',
  `last_login_ip` bigint(20) NOT NULL DEFAULT '0' COMMENT '最后登录IP',
  `update_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '更新时间',
  `status` tinyint(4) DEFAULT '0' COMMENT '用户状态',
  PRIMARY KEY (`id`),
  UNIQUE KEY `username` (`username`) USING BTREE,
  UNIQUE KEY `email` (`email`) USING BTREE,
  KEY `status` (`status`) USING BTREE
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COMMENT='用户表';

-- ----------------------------
-- Records of pb_ucenter_member
-- ----------------------------
BEGIN;
INSERT INTO `pb_ucenter_member` VALUES (1, 'admin', '02571bc54a0a4c08451a187d1929b208', '958369865@qq.com', '', 0, 1493108973, 2062152225, 0, 0, 0, 1);
INSERT INTO `pb_ucenter_member` VALUES (2, 'test', '36544645089bc4b2fa780a579c3ee02a', '958384865@qq.com', '', 0, 1517384782, 2130706433, 0, 0, 0, 1);
COMMIT;

-- ----------------------------
-- Table structure for pb_wechat_department
-- ----------------------------
DROP TABLE IF EXISTS `pb_wechat_department`;
CREATE TABLE `pb_wechat_department` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `parentid` int(11) DEFAULT '1' COMMENT '父亲部门id。根部门id为1',
  `name` varchar(64) DEFAULT NULL COMMENT '部门名称。长度限制为1~64个字节，字符不能包括\\:*?"<>｜',
  `order` int(11) DEFAULT '0' COMMENT '在父部门中的次序值。order值小的排序靠前。',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='微信部门表';

-- ----------------------------
-- Table structure for pb_wechat_department_user
-- ----------------------------
DROP TABLE IF EXISTS `pb_wechat_department_user`;
CREATE TABLE `pb_wechat_department_user` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `departmentid` int(11) unsigned DEFAULT NULL COMMENT '部门ID',
  `userid` varchar(100) DEFAULT NULL COMMENT '用户ID',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='部门用户表';

-- ----------------------------
-- Table structure for pb_wechat_tag
-- ----------------------------
DROP TABLE IF EXISTS `pb_wechat_tag`;
CREATE TABLE `pb_wechat_tag` (
  `id` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
  `tagid` smallint(6) DEFAULT NULL,
  `tagname` varchar(64) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;

-- ----------------------------
-- Table structure for pb_wechat_user
-- ----------------------------
DROP TABLE IF EXISTS `pb_wechat_user`;
CREATE TABLE `pb_wechat_user` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `userid` varchar(64) NOT NULL COMMENT '成员UserID。对应管理端的帐号，企业内必须唯一。',
  `name` varchar(64) NOT NULL COMMENT '成员名称',
  `nickname` varchar(64) DEFAULT NULL COMMENT '昵称',
  `header` varchar(255) DEFAULT NULL COMMENT '头像',
  `department` varchar(255) DEFAULT NULL COMMENT '成员所属部门id列表',
  `position` varchar(64) DEFAULT NULL COMMENT '职位信息',
  `mobile` varchar(20) DEFAULT NULL COMMENT '手机号码',
  `gender` tinyint(4) DEFAULT '0' COMMENT '性别。0未定义、1男性、2女性',
  `email` varchar(64) DEFAULT NULL COMMENT '邮箱。企业内必须唯一',
  `weixinid` varchar(100) DEFAULT NULL COMMENT '微信号。企业内必须唯一。',
  `telephone` varchar(20) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT '',
  `enable` tinyint(4) DEFAULT NULL COMMENT '启用/禁用成员',
  `avatar` varchar(500) DEFAULT NULL COMMENT '头像url。注：如果要获取小图将url最后的"/0"改成"/64"即可',
  `avatar_mediaid` varchar(500) DEFAULT NULL COMMENT '成员头像的mediaid',
  `extattr` longtext COMMENT 'WEB管理添加的扩展属性',
  `unit` varchar(255) DEFAULT NULL COMMENT '所属单位',
  `nation` varchar(50) DEFAULT NULL COMMENT '民族',
  `birthday` varchar(100) DEFAULT NULL COMMENT '出生日期',
  `education` varchar(50) DEFAULT NULL COMMENT '学历',
  `partytime` varchar(50) DEFAULT NULL COMMENT '入党时间',
  `relation` varchar(100) DEFAULT NULL COMMENT '组织关系',
  `english_name` varchar(100) DEFAULT '',
  `hide_mobile` varchar(100) CHARACTER SET utf8 COLLATE utf8_icelandic_ci DEFAULT '',
  `isleader` varchar(100) DEFAULT '',
  `status` tinyint(4) DEFAULT NULL COMMENT '关注状态: 1已关注、2已冻结、4未关注',
  `volunteer_base` int(11) DEFAULT '0' COMMENT '志愿签到  基础分',
  `volunteer_score` int(11) DEFAULT '0' COMMENT '志愿签到  总分',
  `score` int(11) DEFAULT '0' COMMENT '个人累计积分,浏览1分，点赞1分，评论1分',
  `game_score` int(11) DEFAULT '0' COMMENT '游戏模式得分',
  `order` varchar(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='微信用户表';

-- ----------------------------
-- Table structure for pb_wechat_user_tag
-- ----------------------------
DROP TABLE IF EXISTS `pb_wechat_user_tag`;
CREATE TABLE `pb_wechat_user_tag` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `tagid` smallint(11) DEFAULT NULL COMMENT '会议签到标题id',
  `userid` varchar(100) DEFAULT NULL COMMENT '用户id',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;

SET FOREIGN_KEY_CHECKS = 1;
